    drop table ${c.table!""} cascade constraints;
    
    create table ${c.table!""} (
        ID INTEGER not null,
        <#list c.oneToOne as o>
        <#if o.inverse == "false">
        ${o.column} INTEGER not null unique,
        </#if>
        </#list>
        <#list c.manyToOne as mo>
        ${mo.column} INTEGER not null,
        </#list>
        <#list c.properties as p>
        ${p.column}<#if p.type == "String"> VARCHAR2(${p.length})<#elseif p.type == "Long"> INTEGER<#elseif p.type == "Date"> DATE</#if><#if p.notNull == "true"> not null</#if><#if p.unique == "true"> unique</#if>,
        </#list>
        
        STATUS VARCHAR2(1) not null,
        CREATED_USER INTEGER not null,
        CREATED_DATE DATE not null,
        UPDATED_USER INTEGER,
        UPDATED_DATE DATE,
        constraint PK_${c.table!""} primary key (ID)
    );
    
	COMMENT ON COLUMN ${c.table!""}.ID IS '主键(SEQ_${c.table!""})';
	<#list c.oneToOne as o>
    <#if o.inverse == "false">
    
	COMMENT ON COLUMN ${c.table!""}.${o.column} IS '${c.findClass(o.className,config).title}';
    </#if>
    </#list>
    <#list c.manyToOne as mo>
    
    COMMENT ON COLUMN ${c.table!""}.${mo.column} IS '${c.findClass(mo.className,config).title}';
    </#list>
    <#list c.properties as p>
    
	COMMENT ON COLUMN ${c.table!""}.${p.column} IS '${p.element.title}';
    </#list>
	
	COMMENT ON COLUMN ${c.table!""}.STATUS IS '记录是否有效(0,无效,1,有效)';
	
	COMMENT ON COLUMN ${c.table!""}.CREATED_USER IS '创建人(SK_USER.ID)';
	
	COMMENT ON COLUMN ${c.table!""}.CREATED_DATE IS '创建日期(SYSDATE)';
	
	COMMENT ON COLUMN ${c.table!""}.UPDATED_USER IS '修改人(SK_USER.ID)';
	
	COMMENT ON COLUMN ${c.table!""}.UPDATED_DATE IS '修改日期(SYSDATE)';    

    drop sequence SEQ_${c.table!""};
    
    create sequence SEQ_${c.table!""};
    